Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 65281 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 3657 |
| Duplicate rows (%) | 5.6% |
| Total size in memory | 6.5 MiB |
| Average record size in memory | 104.0 B |
Variable types
| Numeric | 10 |
|---|---|
| Text | 1 |
| Categorical | 1 |
| Dataset has 3657 (5.6%) duplicate rows | Duplicates |
Discount Amount is highly overall correlated with Sales Amount and 3 other fields | High correlation |
List Price is highly overall correlated with Sales Price and 1 other fields | High correlation |
Sales Amount is highly overall correlated with Discount Amount and 3 other fields | High correlation |
Sales Amount Based on List Price is highly overall correlated with Discount Amount and 3 other fields | High correlation |
Sales Cost Amount is highly overall correlated with Discount Amount and 3 other fields | High correlation |
Sales Margin Amount is highly overall correlated with Discount Amount and 3 other fields | High correlation |
Sales Price is highly overall correlated with List Price and 1 other fields | High correlation |
Sales Quantity is highly overall correlated with List Price and 1 other fields | High correlation |
Sales Cost Amount is highly skewed (γ1 = 21.01078573) | Skewed |
Sales Quantity is highly skewed (γ1 = 23.00739577) | Skewed |
Discount Amount has 1215 (1.9%) zeros | Zeros |
Reproduction
| Analysis started | 2023-07-09 06:30:40.850514 |
|---|---|
| Analysis finished | 2023-07-09 06:30:55.817760 |
| Duration | 14.97 seconds |
| Software version | ydata-profiling vv4.3.1 |
| Download configuration | config.json |
CustKey
Real number (ℝ)
| Distinct | 615 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10017703 |
| Minimum | 10000453 |
|---|---|
| Maximum | 10027583 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1020.0 KiB |
Quantile statistics
| Minimum | 10000453 |
|---|---|
| 5-th percentile | 10002506 |
| Q1 | 10012715 |
| median | 10019665 |
| Q3 | 10023511 |
| 95-th percentile | 10026006 |
| Maximum | 10027583 |
| Range | 27130 |
| Interquartile range (IQR) | 10796 |
Descriptive statistics
| Standard deviation | 7176.1904 |
|---|---|
| Coefficient of variation (CV) | 0.0007163509 |
| Kurtosis | -0.37137474 |
| Mean | 10017703 |
| Median Absolute Deviation (MAD) | 4886 |
| Skewness | -0.77019433 |
| Sum | 6.5396565 × 1011 |
| Variance | 51497708 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10025919 | 2760 | 4.2% |
| 10019194 | 2752 | 4.2% |
| 10012715 | 1431 | 2.2% |
| 10012226 | 1389 | 2.1% |
| 10025025 | 1143 | 1.8% |
| 10023524 | 1042 | 1.6% |
| 10020515 | 1010 | 1.5% |
| 10017638 | 792 | 1.2% |
| 10022456 | 741 | 1.1% |
| 10002506 | 714 | 1.1% |
| Other values (605) | 51507 |
| Value | Count | Frequency (%) |
| 10000453 | 329 | |
| 10000455 | 19 | < 0.1% |
| 10000456 | 104 | 0.2% |
| 10000457 | 19 | < 0.1% |
| 10000458 | 10 | < 0.1% |
| 10000460 | 120 | 0.2% |
| 10000461 | 251 | |
| 10000462 | 3 | < 0.1% |
| 10000466 | 123 | 0.2% |
| 10000469 | 162 |
| Value | Count | Frequency (%) |
| 10027583 | 25 | < 0.1% |
| 10027575 | 5 | < 0.1% |
| 10027572 | 52 | 0.1% |
| 10027560 | 42 | 0.1% |
| 10027381 | 108 | |
| 10027370 | 235 | |
| 10027356 | 21 | < 0.1% |
| 10027348 | 14 | < 0.1% |
| 10027340 | 35 | 0.1% |
| 10027119 | 176 |
Discount Amount
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 17820 |
|---|---|
| Distinct (%) | 27.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1855.5464 |
| Minimum | -255820.8 |
|---|---|
| Maximum | 343532.66 |
| Zeros | 1215 |
| Zeros (%) | 1.9% |
| Negative | 972 |
| Negative (%) | 1.5% |
| Memory size | 1020.0 KiB |
Quantile statistics
| Minimum | -255820.8 |
|---|---|
| 5-th percentile | 18.68 |
| Q1 | 246.03 |
| median | 441.76 |
| Q3 | 999.76 |
| 95-th percentile | 6353 |
| Maximum | 343532.66 |
| Range | 599353.46 |
| Interquartile range (IQR) | 753.73 |
Descriptive statistics
| Standard deviation | 9037.0746 |
|---|---|
| Coefficient of variation (CV) | 4.8703037 |
| Kurtosis | 379.74186 |
| Mean | 1855.5464 |
| Median Absolute Deviation (MAD) | 233.95 |
| Skewness | 10.84186 |
| Sum | 1.2113193 × 108 |
| Variance | 81668717 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1215 | 1.9% |
| 24.88 | 103 | 0.2% |
| 606.84 | 100 | 0.2% |
| 639.82 | 97 | 0.1% |
| 601.9033 | 93 | 0.1% |
| 402.7 | 93 | 0.1% |
| 634.6133 | 93 | 0.1% |
| 918.1412 | 88 | 0.1% |
| 169.36 | 87 | 0.1% |
| 385.98 | 87 | 0.1% |
| Other values (17810) | 63225 |
| Value | Count | Frequency (%) |
| -255820.8 | 1 | < 0.1% |
| -245587.97 | 1 | < 0.1% |
| -238792.73 | 1 | < 0.1% |
| -231837.6 | 3 | |
| -222564.1 | 3 | |
| -127176 | 1 | < 0.1% |
| -122088.96 | 1 | < 0.1% |
| -84573.72 | 1 | < 0.1% |
| -81190.77 | 1 | < 0.1% |
| -53626 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 343532.66 | 2 | |
| 339103.35 | 1 | < 0.1% |
| 331487.76 | 2 | |
| 327213.75 | 1 | < 0.1% |
| 322454.09 | 1 | < 0.1% |
| 210371 | 4 | |
| 202995 | 4 | |
| 191196.5532 | 2 | |
| 189333.9 | 1 | < 0.1% |
| 182832.8832 | 2 |
Item
Text
| Distinct | 657 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1020.0 KiB |
Length
| Max length | 37 |
|---|---|
| Median length | 32 |
| Mean length | 21.722278 |
| Min length | 8 |
Characters and Unicode
| Total characters | 1418052 |
|---|---|
| Distinct characters | 56 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 30 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Urban Large Eggs |
|---|---|
| 2nd row | Moms Sliced Turkey |
| 3rd row | Cutting Edge Foot-Long Hot Dogs |
| 4th row | Kiwi Lox |
| 5th row | High Top Sweet Onion |
| Value | Count | Frequency (%) |
| canned | 6378 | 2.8% |
| ebony | 5460 | 2.4% |
| cheese | 5194 | 2.3% |
| better | 4570 | 2.0% |
| red | 4271 | 1.9% |
| top | 4173 | 1.8% |
| spade | 4161 | 1.8% |
| high | 4138 | 1.8% |
| best | 3480 | 1.5% |
| nationeel | 3328 | 1.4% |
| Other values (294) | 184534 |
Most occurring characters
| Value | Count | Frequency (%) |
| 164406 | 11.6% | |
| e | 147096 | 10.4% |
| o | 92467 | 6.5% |
| a | 92276 | 6.5% |
| n | 74074 | 5.2% |
| i | 69460 | 4.9% |
| t | 68733 | 4.8% |
| r | 67352 | 4.7% |
| l | 59835 | 4.2% |
| s | 57796 | 4.1% |
| Other values (46) | 524557 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1013747 | |
| Uppercase Letter | 236243 | 16.7% |
| Space Separator | 164406 | 11.6% |
| Dash Punctuation | 2160 | 0.2% |
| Other Punctuation | 748 | 0.1% |
| Decimal Number | 748 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 147096 | |
| o | 92467 | 9.1% |
| a | 92276 | 9.1% |
| n | 74074 | 7.3% |
| i | 69460 | 6.9% |
| t | 68733 | 6.8% |
| r | 67352 | 6.6% |
| l | 59835 | 5.9% |
| s | 57796 | 5.7% |
| d | 40545 | 4.0% |
| Other values (16) | 244113 |
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 31428 | |
| C | 30873 | |
| S | 26130 | |
| T | 19374 | 8.2% |
| F | 16239 | 6.9% |
| M | 12522 | 5.3% |
| P | 11469 | 4.9% |
| L | 11022 | 4.7% |
| D | 10754 | 4.6% |
| E | 10237 | 4.3% |
| Other values (15) | 56195 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 579 | |
| 2 | 169 | 22.6% |
Space Separator
| Value | Count | Frequency (%) |
| 164406 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2160 |
Other Punctuation
| Value | Count | Frequency (%) |
| % | 748 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1249990 | |
| Common | 168062 | 11.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 147096 | 11.8% |
| o | 92467 | 7.4% |
| a | 92276 | 7.4% |
| n | 74074 | 5.9% |
| i | 69460 | 5.6% |
| t | 68733 | 5.5% |
| r | 67352 | 5.4% |
| l | 59835 | 4.8% |
| s | 57796 | 4.6% |
| d | 40545 | 3.2% |
| Other values (41) | 480356 |
Common
| Value | Count | Frequency (%) |
| 164406 | ||
| - | 2160 | 1.3% |
| % | 748 | 0.4% |
| 1 | 579 | 0.3% |
| 2 | 169 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1418052 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 164406 | 11.6% | |
| e | 147096 | 10.4% |
| o | 92467 | 6.5% |
| a | 92276 | 6.5% |
| n | 74074 | 5.2% |
| i | 69460 | 4.9% |
| t | 68733 | 4.8% |
| r | 67352 | 4.7% |
| l | 59835 | 4.2% |
| s | 57796 | 4.1% |
| Other values (46) | 524557 |
List Price
Real number (ℝ)
HIGH CORRELATION
| Distinct | 1062 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 514.70126 |
| Minimum | 0 |
|---|---|
| Maximum | 2760.7 |
| Zeros | 295 |
| Zeros (%) | 0.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1020.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 36.69 |
| Q1 | 181.56 |
| median | 325.19 |
| Q3 | 803.86 |
| 95-th percentile | 1431.23 |
| Maximum | 2760.7 |
| Range | 2760.7 |
| Interquartile range (IQR) | 622.3 |
Descriptive statistics
| Standard deviation | 449.18811 |
|---|---|
| Coefficient of variation (CV) | 0.87271615 |
| Kurtosis | 0.012496642 |
| Mean | 514.70126 |
| Median Absolute Deviation (MAD) | 217.35 |
| Skewness | 1.0054596 |
| Sum | 33600213 |
| Variance | 201769.95 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 298 | 1508 | 2.3% |
| 1431.23 | 1426 | 2.2% |
| 966.44 | 1192 | 1.8% |
| 1275.1 | 1126 | 1.7% |
| 192.34 | 1041 | 1.6% |
| 1627.84 | 1035 | 1.6% |
| 157.76 | 988 | 1.5% |
| 1084.61 | 975 | 1.5% |
| 181.44 | 893 | 1.4% |
| 412.03 | 892 | 1.4% |
| Other values (1052) | 54205 |
| Value | Count | Frequency (%) |
| 0 | 295 | |
| 0.3929 | 150 | |
| 0.4 | 21 | < 0.1% |
| 0.405 | 25 | < 0.1% |
| 0.41 | 10 | < 0.1% |
| 0.445 | 6 | < 0.1% |
| 0.52 | 1 | < 0.1% |
| 0.61 | 4 | < 0.1% |
| 1.6236 | 2 | < 0.1% |
| 1.8711 | 9 | < 0.1% |
| Value | Count | Frequency (%) |
| 2760.7 | 12 | < 0.1% |
| 2291.4 | 7 | < 0.1% |
| 2267 | 10 | < 0.1% |
| 1975 | 113 | |
| 1920 | 61 | |
| 1880 | 19 | < 0.1% |
| 1759.4 | 45 | 0.1% |
| 1731.4 | 35 | 0.1% |
| 1691.4 | 12 | < 0.1% |
| 1688.13 | 150 |
Sales Amount
Real number (ℝ)
HIGH CORRELATION
| Distinct | 17895 |
|---|---|
| Distinct (%) | 27.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2852.0055 |
| Minimum | 200.01 |
|---|---|
| Maximum | 555376 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1020.0 KiB |
Quantile statistics
| Minimum | 200.01 |
|---|---|
| 5-th percentile | 215.78 |
| Q1 | 308.38 |
| median | 553.94 |
| Q3 | 1279.96 |
| 95-th percentile | 8777.79 |
| Maximum | 555376 |
| Range | 555175.99 |
| Interquartile range (IQR) | 971.58 |
Descriptive statistics
| Standard deviation | 15164.456 |
|---|---|
| Coefficient of variation (CV) | 5.3171202 |
| Kurtosis | 478.90724 |
| Mean | 2852.0055 |
| Median Absolute Deviation (MAD) | 292.92 |
| Skewness | 18.578552 |
| Sum | 1.8618177 × 108 |
| Variance | 2.2996072 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 784.97 | 115 | 0.2% |
| 817.68 | 115 | 0.2% |
| 294.72 | 110 | 0.2% |
| 307 | 104 | 0.2% |
| 597.14 | 102 | 0.2% |
| 622.02 | 101 | 0.2% |
| 824.39 | 100 | 0.2% |
| 791.41 | 99 | 0.2% |
| 401.16 | 95 | 0.1% |
| 204.66 | 92 | 0.1% |
| Other values (17885) | 64248 |
| Value | Count | Frequency (%) |
| 200.01 | 6 | |
| 200.06 | 6 | |
| 200.08 | 1 | < 0.1% |
| 200.14 | 3 | |
| 200.15 | 5 | |
| 200.19 | 7 | |
| 200.21 | 1 | < 0.1% |
| 200.3 | 3 | |
| 200.36 | 1 | < 0.1% |
| 200.37 | 6 |
| Value | Count | Frequency (%) |
| 555376 | 1 | < 0.1% |
| 539200 | 5 | |
| 517632 | 5 | |
| 472069.6 | 2 | < 0.1% |
| 458320 | 5 | |
| 439987.2 | 5 | |
| 310156.07 | 1 | < 0.1% |
| 301122.4 | 2 | < 0.1% |
| 297240 | 1 | < 0.1% |
| 289077.5 | 2 | < 0.1% |
Sales Amount Based on List Price
Real number (ℝ)
HIGH CORRELATION
| Distinct | 4060 |
|---|---|
| Distinct (%) | 6.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4707.5457 |
| Minimum | 0 |
|---|---|
| Maximum | 632610.16 |
| Zeros | 295 |
| Zeros (%) | 0.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1020.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 390 |
| Q1 | 561.04 |
| median | 998.16 |
| Q3 | 2315.04 |
| 95-th percentile | 16425.12 |
| Maximum | 632610.16 |
| Range | 632610.16 |
| Interquartile range (IQR) | 1754 |
Descriptive statistics
| Standard deviation | 20696.594 |
|---|---|
| Coefficient of variation (CV) | 4.3964722 |
| Kurtosis | 278.71143 |
| Mean | 4707.5457 |
| Median Absolute Deviation (MAD) | 524.88 |
| Skewness | 14.074724 |
| Sum | 3.0731329 × 108 |
| Variance | 4.2834901 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1431.23 | 590 | 0.9% |
| 1627.84 | 530 | 0.8% |
| 803.86 | 498 | 0.8% |
| 596 | 448 | 0.7% |
| 1254.1899 | 418 | 0.6% |
| 966.44 | 376 | 0.6% |
| 439.7 | 372 | 0.6% |
| 507.75 | 363 | 0.6% |
| 767.75 | 348 | 0.5% |
| 939.57 | 343 | 0.5% |
| Other values (4050) | 60995 |
| Value | Count | Frequency (%) |
| 0 | 295 | |
| 194 | 2 | < 0.1% |
| 195.61 | 1 | < 0.1% |
| 198.396 | 1 | < 0.1% |
| 198.63 | 1 | < 0.1% |
| 200.7 | 8 | < 0.1% |
| 200.8 | 1 | < 0.1% |
| 201.69 | 3 | < 0.1% |
| 202.14 | 1 | < 0.1% |
| 202.6 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 632610.16 | 5 | |
| 624453.75 | 2 | < 0.1% |
| 539200 | 11 | |
| 458320 | 12 | |
| 391924.7232 | 5 | |
| 387395 | 8 | |
| 348655.5 | 2 | < 0.1% |
| 332196.405 | 2 | < 0.1% |
| 330708.3792 | 5 | |
| 310273.7392 | 2 | < 0.1% |
Sales Cost Amount
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 5513 |
|---|---|
| Distinct (%) | 8.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1661.0047 |
| Minimum | 0 |
|---|---|
| Maximum | 366576 |
| Zeros | 348 |
| Zeros (%) | 0.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1020.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 85.36 |
| Q1 | 167.79 |
| median | 304.5 |
| Q3 | 687.4 |
| 95-th percentile | 4946.11 |
| Maximum | 366576 |
| Range | 366576 |
| Interquartile range (IQR) | 519.61 |
Descriptive statistics
| Standard deviation | 9556.5562 |
|---|---|
| Coefficient of variation (CV) | 5.7534794 |
| Kurtosis | 614.26709 |
| Mean | 1661.0047 |
| Median Absolute Deviation (MAD) | 171.25 |
| Skewness | 21.010786 |
| Sum | 1.0843205 × 108 |
| Variance | 91327767 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 449.69 | 534 | 0.8% |
| 475.75 | 457 | 0.7% |
| 0 | 348 | 0.5% |
| 134.67 | 305 | 0.5% |
| 162.89 | 289 | 0.4% |
| 205.72 | 253 | 0.4% |
| 159.14 | 242 | 0.4% |
| 16718.08 | 234 | 0.4% |
| 546.44 | 231 | 0.4% |
| 344.28 | 229 | 0.4% |
| Other values (5503) | 62159 |
| Value | Count | Frequency (%) |
| 0 | 348 | |
| 12.97 | 2 | < 0.1% |
| 19.55 | 4 | < 0.1% |
| 20.8 | 6 | < 0.1% |
| 26 | 1 | < 0.1% |
| 31.19 | 4 | < 0.1% |
| 33.97 | 3 | < 0.1% |
| 35.48 | 2 | < 0.1% |
| 35.54 | 5 | < 0.1% |
| 36.03 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 366576 | 7 | < 0.1% |
| 353292.8 | 4 | < 0.1% |
| 311589.6 | 12 | < 0.1% |
| 185048.85 | 2 | < 0.1% |
| 161446.35 | 5 | < 0.1% |
| 157412.85 | 2 | < 0.1% |
| 153635.03 | 5 | < 0.1% |
| 146630.4 | 4 | < 0.1% |
| 141265.56 | 36 | |
| 137736.24 | 4 | < 0.1% |
Sales Margin Amount
Real number (ℝ)
HIGH CORRELATION
| Distinct | 21295 |
|---|---|
| Distinct (%) | 32.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1191.0008 |
| Minimum | -3932.93 |
|---|---|
| Maximum | 188800 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Negative | 576 |
| Negative (%) | 0.9% |
| Memory size | 1020.0 KiB |
Quantile statistics
| Minimum | -3932.93 |
|---|---|
| 5-th percentile | 61.54 |
| Q1 | 129.95 |
| median | 246.49 |
| Q3 | 579.32 |
| 95-th percentile | 3824.43 |
| Maximum | 188800 |
| Range | 192732.93 |
| Interquartile range (IQR) | 449.37 |
Descriptive statistics
| Standard deviation | 5860.8134 |
|---|---|
| Coefficient of variation (CV) | 4.9209148 |
| Kurtosis | 324.93262 |
| Mean | 1191.0008 |
| Median Absolute Deviation (MAD) | 140.28 |
| Skewness | 15.571533 |
| Sum | 77749723 |
| Variance | 34349134 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 374.7 | 93 | 0.1% |
| 5317.17 | 88 | 0.1% |
| 6235.31 | 87 | 0.1% |
| 341.72 | 84 | 0.1% |
| 15.32 | 69 | 0.1% |
| 37.08 | 67 | 0.1% |
| 52.8 | 67 | 0.1% |
| 431.88 | 64 | 0.1% |
| 464.59 | 64 | 0.1% |
| 24.53 | 63 | 0.1% |
| Other values (21285) | 64535 |
| Value | Count | Frequency (%) |
| -3932.93 | 1 | |
| -3764.4 | 2 | |
| -3673.68 | 2 | |
| -3608.81 | 1 | |
| -3414.01 | 2 | |
| -3132.65 | 2 | |
| -2533.97 | 2 | |
| -2508.21 | 2 | |
| -2488.89 | 1 | |
| -2103.04 | 2 |
| Value | Count | Frequency (%) |
| 188800 | 1 | < 0.1% |
| 185907.2 | 2 | |
| 172624 | 3 | |
| 164339.2 | 2 | |
| 160480 | 2 | |
| 156773.4 | 1 | < 0.1% |
| 156521.04 | 1 | < 0.1% |
| 151056 | 3 | |
| 148401.6 | 3 | |
| 147487.37 | 2 |
Sales Price
Real number (ℝ)
HIGH CORRELATION
| Distinct | 14789 |
|---|---|
| Distinct (%) | 22.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 283.69251 |
| Minimum | 0 |
|---|---|
| Maximum | 6035 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1020.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 22.425556 |
| Q1 | 100.07 |
| median | 183.7575 |
| Q3 | 448.22 |
| 95-th percentile | 789.66 |
| Maximum | 6035 |
| Range | 6035 |
| Interquartile range (IQR) | 348.15 |
Descriptive statistics
| Standard deviation | 252.03218 |
|---|---|
| Coefficient of variation (CV) | 0.88839913 |
| Kurtosis | 6.8824229 |
| Mean | 283.69251 |
| Median Absolute Deviation (MAD) | 116.4725 |
| Skewness | 1.4189747 |
| Sum | 18519730 |
| Variance | 63520.217 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 140.43 | 191 | 0.3% |
| 817.68 | 189 | 0.3% |
| 133.41 | 181 | 0.3% |
| 783.17 | 138 | 0.2% |
| 824.39 | 138 | 0.2% |
| 23.47 | 136 | 0.2% |
| 82.87333333 | 125 | 0.2% |
| 221.04 | 120 | 0.2% |
| 230.25 | 120 | 0.2% |
| 230.98 | 120 | 0.2% |
| Other values (14779) | 63823 |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 0.3373411765 | 2 | < 0.1% |
| 0.3514 | 1 | < 0.1% |
| 0.3619411765 | 1 | < 0.1% |
| 0.37718 | 67 | |
| 0.384 | 9 | < 0.1% |
| 0.3888 | 12 | < 0.1% |
| 0.3929 | 67 | |
| 0.3936 | 5 | < 0.1% |
| 0.4 | 9 | < 0.1% |
| Value | Count | Frequency (%) |
| 6035 | 1 | |
| 3748 | 2 | |
| 3233.36 | 1 | |
| 3009.86 | 1 | |
| 3003.41 | 1 | |
| 2823 | 1 | |
| 2753.32 | 1 | |
| 2560 | 1 | |
| 2540.17 | 1 | |
| 2360.1 | 1 |
Sales Quantity
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 280 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 45.085017 |
| Minimum | 0 |
|---|---|
| Maximum | 16000 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1020.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 8 |
| 95-th percentile | 86 |
| Maximum | 16000 |
| Range | 16000 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 429.66505 |
|---|---|
| Coefficient of variation (CV) | 9.5301072 |
| Kurtosis | 649.74753 |
| Mean | 45.085017 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 23.007396 |
| Sum | 2943195 |
| Variance | 184612.05 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 15264 | |
| 2 | 13466 | |
| 3 | 7056 | |
| 4 | 4973 | 7.6% |
| 5 | 3519 | 5.4% |
| 6 | 3061 | 4.7% |
| 10 | 2596 | 4.0% |
| 8 | 1460 | 2.2% |
| 12 | 1314 | 2.0% |
| 20 | 1034 | 1.6% |
| Other values (270) | 11538 |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 1 | 15264 | |
| 2 | 13466 | |
| 3 | 7056 | |
| 4 | 4973 | 7.6% |
| 5 | 3519 | 5.4% |
| 6 | 3061 | 4.7% |
| 7 | 711 | 1.1% |
| 8 | 1460 | 2.2% |
| 9 | 453 | 0.7% |
| Value | Count | Frequency (%) |
| 16000 | 11 | < 0.1% |
| 13600 | 12 | < 0.1% |
| 9504 | 7 | < 0.1% |
| 8316 | 40 | |
| 7128 | 21 | |
| 7126 | 2 | < 0.1% |
| 6480 | 2 | < 0.1% |
| 6400 | 4 | < 0.1% |
| 5834 | 4 | < 0.1% |
| 4752 | 13 | < 0.1% |
Year
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1020.0 KiB |
| 2017 | |
|---|---|
| 2019 | |
| 2018 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 261124 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2017 |
|---|---|
| 2nd row | 2017 |
| 3rd row | 2017 |
| 4th row | 2017 |
| 5th row | 2017 |
Common Values
| Value | Count | Frequency (%) |
| 2017 | 30574 | |
| 2019 | 28021 | |
| 2018 | 6686 | 10.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2017 | 30574 | |
| 2019 | 28021 | |
| 2018 | 6686 | 10.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 65281 | |
| 0 | 65281 | |
| 1 | 65281 | |
| 7 | 30574 | |
| 9 | 28021 | |
| 8 | 6686 | 2.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 261124 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 65281 | |
| 0 | 65281 | |
| 1 | 65281 | |
| 7 | 30574 | |
| 9 | 28021 | |
| 8 | 6686 | 2.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 261124 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 65281 | |
| 0 | 65281 | |
| 1 | 65281 | |
| 7 | 30574 | |
| 9 | 28021 | |
| 8 | 6686 | 2.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 261124 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 65281 | |
| 0 | 65281 | |
| 1 | 65281 | |
| 7 | 30574 | |
| 9 | 28021 | |
| 8 | 6686 | 2.6% |
Month
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.3070265 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1020.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.5635367 |
|---|---|
| Coefficient of variation (CV) | 0.56501058 |
| Kurtosis | -1.3040676 |
| Mean | 6.3070265 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.076473773 |
| Sum | 411729 |
| Variance | 12.698794 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 3 | 7308 | |
| 2 | 6556 | |
| 1 | 6066 | |
| 12 | 5645 | |
| 9 | 5555 | |
| 6 | 5376 | |
| 10 | 5250 | |
| 11 | 5247 | |
| 5 | 5167 | |
| 8 | 4738 | |
| Other values (2) | 8373 |
| Value | Count | Frequency (%) |
| 1 | 6066 | |
| 2 | 6556 | |
| 3 | 7308 | |
| 4 | 3977 | |
| 5 | 5167 | |
| 6 | 5376 | |
| 7 | 4396 | |
| 8 | 4738 | |
| 9 | 5555 | |
| 10 | 5250 |
| Value | Count | Frequency (%) |
| 12 | 5645 | |
| 11 | 5247 | |
| 10 | 5250 | |
| 9 | 5555 | |
| 8 | 4738 | |
| 7 | 4396 | |
| 6 | 5376 | |
| 5 | 5167 | |
| 4 | 3977 | |
| 3 | 7308 |
| CustKey | Discount Amount | List Price | Sales Amount | Sales Amount Based on List Price | Sales Cost Amount | Sales Margin Amount | Sales Price | Sales Quantity | Month | Year | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| CustKey | 1.000 | -0.016 | -0.008 | 0.015 | 0.006 | 0.019 | 0.011 | -0.004 | 0.011 | 0.008 | 0.171 |
| Discount Amount | -0.016 | 1.000 | 0.438 | 0.823 | 0.896 | 0.783 | 0.731 | 0.367 | 0.380 | 0.042 | 0.000 |
| List Price | -0.008 | 0.438 | 1.000 | 0.356 | 0.383 | 0.389 | 0.285 | 0.977 | -0.542 | -0.005 | 0.005 |
| Sales Amount | 0.015 | 0.823 | 0.356 | 1.000 | 0.967 | 0.930 | 0.890 | 0.358 | 0.484 | 0.009 | 0.011 |
| Sales Amount Based on List Price | 0.006 | 0.896 | 0.383 | 0.967 | 1.000 | 0.913 | 0.859 | 0.346 | 0.476 | 0.023 | 0.000 |
| Sales Cost Amount | 0.019 | 0.783 | 0.389 | 0.930 | 0.913 | 1.000 | 0.706 | 0.373 | 0.423 | 0.013 | 0.000 |
| Sales Margin Amount | 0.011 | 0.731 | 0.285 | 0.890 | 0.859 | 0.706 | 1.000 | 0.300 | 0.474 | 0.005 | 0.012 |
| Sales Price | -0.004 | 0.367 | 0.977 | 0.358 | 0.346 | 0.373 | 0.300 | 1.000 | -0.567 | -0.018 | 0.024 |
| Sales Quantity | 0.011 | 0.380 | -0.542 | 0.484 | 0.476 | 0.423 | 0.474 | -0.567 | 1.000 | 0.025 | 0.000 |
| Month | 0.008 | 0.042 | -0.005 | 0.009 | 0.023 | 0.013 | 0.005 | -0.018 | 0.025 | 1.000 | 0.366 |
| Year | 0.171 | 0.000 | 0.005 | 0.011 | 0.000 | 0.000 | 0.012 | 0.024 | 0.000 | 0.366 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| CustKey | Discount Amount | Item | List Price | Sales Amount | Sales Amount Based on List Price | Sales Cost Amount | Sales Margin Amount | Sales Price | Sales Quantity | Year | Month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 10000481 | -237.910 | Urban Large Eggs | 0.000 | 237.91 | 0.000 | 0.0 | 237.91 | 237.910000 | 1 | 2017 | 4 |
| 1 | 10002220 | 368.790 | Moms Sliced Turkey | 824.960 | 456.17 | 824.960 | 0.0 | 456.17 | 456.170000 | 1 | 2017 | 7 |
| 2 | 10002220 | 109.730 | Cutting Edge Foot-Long Hot Dogs | 548.660 | 438.93 | 548.660 | 0.0 | 438.93 | 438.930000 | 1 | 2017 | 10 |
| 3 | 10002489 | -211.750 | Kiwi Lox | 0.000 | 211.75 | 0.000 | 0.0 | 211.75 | 211.750000 | 1 | 2017 | 6 |
| 4 | 10004516 | 96627.940 | High Top Sweet Onion | 408.520 | 89248.66 | 185876.600 | 0.0 | 89248.66 | 196.150901 | 455 | 2017 | 5 |
| 5 | 10004516 | -1950.000 | Best Choice Fudge Brownies | 0.000 | 1950.00 | 0.000 | 0.0 | 1950.00 | 1950.000000 | 1 | 2017 | 5 |
| 6 | 10007866 | 371.014 | Moms Sliced Turkey | 795.314 | 424.30 | 795.314 | 0.0 | 424.30 | 424.300000 | 1 | 2017 | 9 |
| 7 | 10009356 | 608.080 | Tell Tale Garlic | 575.000 | 541.92 | 1150.000 | 0.0 | 541.92 | 270.960000 | 2 | 2017 | 6 |
| 8 | 10009356 | 424.800 | High Top Walnuts | 51.880 | 353.40 | 778.200 | 0.0 | 353.40 | 23.560000 | 15 | 2017 | 6 |
| 9 | 10009356 | 13492.800 | Big Time Frozen Cheese Pizza | 412.030 | 11229.00 | 24721.800 | 0.0 | 11229.00 | 187.150000 | 60 | 2017 | 6 |
| CustKey | Discount Amount | Item | List Price | Sales Amount | Sales Amount Based on List Price | Sales Cost Amount | Sales Margin Amount | Sales Price | Sales Quantity | Year | Month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 65272 | 10017638 | 596.32 | Blue Label Canned Beets | 634.11 | 671.90 | 1268.22 | 544.11 | 127.79 | 335.950000 | 2 | 2018 | 3 |
| 65273 | 10017638 | 4654.76 | Moms Sliced Turkey | 824.96 | 5244.76 | 9899.52 | 3058.48 | 2186.28 | 437.063333 | 12 | 2018 | 3 |
| 65274 | 10017638 | 1582.78 | Gorilla Strawberry Yogurt | 187.01 | 1783.40 | 3366.18 | 768.23 | 1015.17 | 99.077778 | 18 | 2018 | 3 |
| 65275 | 10017638 | 1095.70 | Gorilla Jack Cheese | 1103.00 | 1110.30 | 2206.00 | 844.55 | 265.75 | 555.150000 | 2 | 2018 | 3 |
| 65276 | 10017638 | 277.61 | Blue Label Fancy Canned Oysters | 14.76 | 312.79 | 590.40 | 268.40 | 44.39 | 7.819750 | 40 | 2018 | 3 |
| 65277 | 10017638 | 505.78 | High Top Oranges | 119.52 | 569.90 | 1075.68 | 239.95 | 329.95 | 63.322222 | 9 | 2018 | 3 |
| 65278 | 10017638 | 410.75 | Landslide White Sugar | 436.78 | 462.81 | 873.56 | 423.55 | 39.26 | 231.405000 | 2 | 2018 | 3 |
| 65279 | 10017638 | 876.16 | Moms Potato Salad | 232.92 | 987.20 | 1863.36 | 574.00 | 413.20 | 123.400000 | 8 | 2018 | 3 |
| 65280 | 10017638 | 24226.77 | Better Fancy Canned Sardines | 1431.23 | 27297.51 | 51524.28 | 16188.90 | 11108.61 | 758.264167 | 36 | 2018 | 3 |
| 65281 | 10017638 | 24479.26 | Imagine Popsicles | 1084.61 | 27582.02 | 52061.28 | 14234.22 | 13347.80 | 574.625417 | 48 | 2018 | 3 |
Most frequently occurring
| CustKey | Discount Amount | Item | List Price | Sales Amount | Sales Amount Based on List Price | Sales Cost Amount | Sales Margin Amount | Sales Price | Sales Quantity | Year | Month | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3092 | 10025552 | 601.9033 | Washington Apple Drink | 1419.5833 | 817.68 | 1419.5833 | 353.09 | 464.59 | 817.68 | 1 | 2017 | 10 | 21 |
| 850 | 10013080 | 634.6133 | Washington Apple Drink | 1419.5833 | 784.97 | 1419.5833 | 353.09 | 431.88 | 784.97 | 1 | 2019 | 10 | 20 |
| 852 | 10013080 | 634.6133 | Washington Apple Drink | 1419.5833 | 784.97 | 1419.5833 | 353.09 | 431.88 | 784.97 | 1 | 2019 | 12 | 20 |
| 3094 | 10025552 | 601.9033 | Washington Apple Drink | 1419.5833 | 817.68 | 1419.5833 | 353.09 | 464.59 | 817.68 | 1 | 2017 | 12 | 20 |
| 422 | 10008638 | 24.8800 | High Top Walnuts | 622.0200 | 597.14 | 622.0200 | 286.38 | 310.76 | 597.14 | 1 | 2019 | 6 | 16 |
| 851 | 10013080 | 634.6133 | Washington Apple Drink | 1419.5833 | 784.97 | 1419.5833 | 353.09 | 431.88 | 784.97 | 1 | 2019 | 11 | 16 |
| 2390 | 10021986 | 0.0000 | High Top Walnuts | 622.0200 | 622.02 | 622.0200 | 286.38 | 335.64 | 622.02 | 1 | 2017 | 6 | 15 |
| 428 | 10008638 | 24.8800 | High Top Walnuts | 622.0200 | 597.14 | 622.0200 | 287.65 | 309.49 | 597.14 | 1 | 2019 | 12 | 14 |
| 853 | 10013080 | 634.6133 | Washington Apple Drink | 1419.5833 | 784.97 | 1419.5833 | 359.20 | 425.77 | 784.97 | 1 | 2019 | 3 | 14 |
| 854 | 10013080 | 634.6133 | Washington Apple Drink | 1419.5833 | 784.97 | 1419.5833 | 359.20 | 425.77 | 784.97 | 1 | 2019 | 9 | 14 |